IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Club_SaveInfo]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Club_SaveInfo]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Sodor_Factor]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Sodor_Factor]

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Sp_SodorFactor_Retail]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Sp_SodorFactor_Retail]


IF EXISTS
(
    SELECT *
    FROM dbo.sysobjects
    WHERE id = OBJECT_ID(N'[dbo].[LESS_Mojodi]')
          AND xtype IN ( N'FN', N'IF', N'TF' )
)
    DROP FUNCTION [dbo].[LESS_Mojodi]

IF EXISTS
(
    SELECT 1
    FROM sys.procedures p
    WHERE p.name = 'Delete_Mandeh_Data'
)
    DROP PROCEDURE [dbo].[Delete_Mandeh_Data]

IF EXISTS
(
    SELECT 1
    FROM sys.procedures p
    WHERE p.name = 'STIGetInfoAcc'
)
    DROP PROCEDURE [dbo].[STIGetInfoAcc] 

IF EXISTS ( SELECT  *
            FROM    dbo.sysobjects
            WHERE   id = OBJECT_ID(N'[dbo].[Subsidy_UpdateTmpHavaleh_Over_Under]')
                    AND OBJECTPROPERTY(id, N'IsProcedure') = 1 )
    DROP PROCEDURE [dbo].[Subsidy_UpdateTmpHavaleh_Over_Under]





